SalesMeterReading

Entity Definition

Logical Name : SalesMeterReading
Physical Name : DO_RDG_MTR_SLS

The value of a SALES METER recorded at a particular time for a particular reason.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer SalesMeter(AS_MTR_SLS)
SalesMeterID (FK)(PK) A system-assigned unique identifier for a sales meter. ID_MTR_SLS Identity integer SalesMeter(AS_MTR_SLS)
ReadingNumber (PK) A sequential number uniquely identifying this particular reading within the context of the SaleMeter being used. AI_RDG LineNumber smallint
MeterReadingQuantity The Meter Reading value. QY_RDG Quantity decimal(9,2)
TimeStamp The date & time the meter reading was taken TS_RDG AuditDateTime datetime
ReasonCode A 2 character code denoting the reason the meter reading was taken RC_RDG Code varchar(20)
TransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) ForecourtSettlementTransaction(TR_STLM_FCRT)

Relationships

Parent Entity Verb Phrase Child Entity
SalesMeter records SalesMeterReading
ForecourtSettlementTransaction causes SalesMeterReading

Logical Views containing SalesMeterReading

Logical View
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View
Logical 20040 - Forecourt History View